
select id,name,entity,ft.UsageScope,ft.Rank,ft.LayoutControlAssembly,ft.LayoutControlClass,ft.LayoutControlObject from vwFormTemplates ft
where ft.LayoutControlClass <> '' and 
ft.LayoutControlClass not in
(
'Aptify.Framework.Messaging.MessagePartLayout'
,'Aptify.Applications.Tasks.TaskLayout'
,'Aptify.Framework.Licensing.LicenseLayoutControl'
,'Aptify.Applications.Inventory.ProductInvLedgerEntryGeneral'
,'Aptify.Framework.BusinessLogic.Entity.Employees.EmployeesFormLayout'
,'Aptify.Applications.CommitteeTerm.CommitteeTermGUI'
,'Aptify.Applications.Organization.OrganizationLayout'
,'Aptify.Applications.PersonCompanies.PersonCompaniesLayout.PersonCompaniesFormLayout'
,'Aptify.Applications.Companies.CompaniesLayout'
,'Aptify.Applications.Accounting.SchedTransGroupsLayout.ScheduleTransactionsGroupsLayout'
,'Aptify.Applications.Accounting.ScheduledTransactionLayout'
,'Aptify.Applications.ProductSetup.WindowsControls.ProductPriceLayout'
,'Aptify.Applications.ExpoManagement.BoothsLayout'
,'Aptify.Applications.OrderEntry.OrderExpoDetailLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderShipmentTaxesLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderLineTaxesLayout'
,'Aptify.Applications.ProductSetup.WindowsControls.ProductCategoryLayout'
,'Aptify.Applications.Subscriptions.WindowsControls.SubscriptionLayout'
,'Aptify.Applications.ProductSetup.WindowsControls.ProductLayout'
,'Aptify.Applications.Persons.PersonsLayout'
,'Aptify.Applications.MeetingManagement.MeetingsLayout'
,'Aptify.Applications.OrderEntry.Payments.PaymentLayout'
,'Aptify.Applications.OrderEntry.Payments.PaymentAuthorizationsLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderLayout'
,'Aptify.Applications.ContactManagement.WindowsControls.ContactLogLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderGLEntryLayout'
,'Aptify.Applications.Companies.CompanySPMLayout'
,'Aptify.Applications.Persons.PersonSPMLayout'
,'Aptify.Applications.Accounting.SalesTaxRateLayout'
,'Aptify.Applications.Accounting.TaxJurisdictionsLayout'
,'Aptify.Applications.Campaigns.CampaignDiscountLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderMeetingDetailLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderLinesLayout'
,'Aptify.Applications.OrderEntry.Payments.PaymentLinesLayout'
,'Aptify.Applications.Campaigns.CampaignDiscountLayout'
,'Aptify.Applications.Campaigns.CampaignSegmentLayout'
,'Aptify.Applications.OrderEntry.ShipmentTypeMatrixLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderShipmentsLayout'
,'Aptify.Framework.BusinessLogic.Entity.EntitySubTables.EntitySubTablesFormLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderPaymentsLayout'
,'Aptify.Applications.OrderEntry.Payments.PaymentGLEntriesLayout'
,'Aptify.Applications.Tasks.TaskTypeActionLayout'
,'Aptify.Applications.Accounting.WindowsControls.StandingOrderLayout'
,'Aptify.Applications.Subscriptions.WindowsControls.SubscriptionFulfillmentsLayout'
,'Aptify.Applications.Housing.HousingReservationGuestLayout'
,'Aptify.Framework.Messaging.MessageTemplateLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.BulkOrderCustomerProductOverridesLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.BulkOrderProductsLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.BulkOrderLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.BulkOrderCustomersLayout'
,'Aptify.Application.Wizards.Wizards'
,'Aptify.Application.DataSetGUI.DataSetLayout'
,'Aptify.Applications.CaseManagement.DisableFields'
,'Aptify.Applications.Commissions.CommissionPlanLayout'
,'Aptify.Applications.Commissions.CommissionPlanItemLayout'
,'Aptify.Applications.Commissions.CommissionRateScaleLayout'
,'Aptify.Applications.Commissions.CommissionAgmtDetTierLayout'
,'Aptify.Applications.Commissions.CommissionAgmtDetTierLayout'
,'Aptify.Applications.Commissions.CommissionAgmtDetailLayout'
,'Aptify.Applications.Commissions.CommissionAgreementLayout'
,'Aptify.Applications.Commissions.CommissionPayDetAdjustmentsLayout'
,'Aptify.Applications.Commissions.CommissionPaySourceDetailsLayout'
,'Aptify.Applications.Commissions.CommissionPaySourceDetailsLayout'
,'Aptify.Applications.Commissions.CommissionPayDetailLayout'
,'Aptify.Applications.Advertising.AdvertisingRateCardDeadline'
,'Aptify.Applications.Advertising.AdvertisingRateCardSectionLayout'
,'Aptify.Applications.Advertising.AdvertisingRateCardLayout'
,'Aptify.Applications.Advertising.AdvertisingRateCardLayout'
,'Aptify.Applications.Advertising.AdvertisingContractPubLayout'
,'Aptify.Applications.Advertising.AdvertisingContractSalesRepLayout'
,'Aptify.Applications.Advertising.AdvertisingContractLayout'
,'Aptify.Applications.Advertising.InsertionOrderAdjHistoryLayout'
,'Aptify.Applications.Advertising.InsertionMultiBillToLayout'
,'Aptify.Applications.Advertising.InsertionOrderDetailLayout'
,'Aptify.Applications.Advertising.InsertionOrderLayout'
,'Aptify.Applications.Fundraising.FundraisingCampaignsLayout'
,'Aptify.Applications.Fundraising.PledgePaymentScheduleLayout'
,'Aptify.Applications.Fundraising.PledgeLayoutControl'
,'Aptify.Applications.Fundraising.MatchRulesLayout'
,'Aptify.Applications.Fundraising.DonorAdvisedFundsLayoutControl'
,'Aptify.Applications.Fundraising.DisbursementsLayout'
,'Aptify.Applications.Fundraising.GrantLayoutControl'
,'Aptify.Applications.Fundraising.DAFAllocationLayout'
,'Aptify.Applications.Fundraising.SolicitorGUI'
,'Aptify.Applications.Education.CoursesLayout'
,'Aptify.Applications.Education.ClassesLayout'
,'Aptify.Applications.Education.WindowsControls.ClassRegistrationPaymentLayout'
,'Aptify.Applications.Education.WindowsControls.ClassRegistrationLayout'
,'Aptify.Applications.Education.AnswerSheetLayout'
,'Aptify.Applications.EntityAction.EntityActionPermissionLayout'
,'Aptify.Applications.BulkWriteOffWizard.CreateBulkWriteOffGUI'
,'Aptify.Framework.Messaging.MessageRunLayout'
,'Aptify.Framework.Messaging.MessageRunActionLayout'
,'Aptify.Framework.Messaging.MessageRunLayout'
,'Aptify.Framework.Messaging.MessageRunActionLayout'
,'Aptify.Framework.FullText.FullTextIndexFieldFormLayout'
,'Aptify.Framework.FullText.FullTextIndexFormLayout'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityFullTextIndexFiltersLayout'
,'Aptify.Applications.MeetingManagement.MeetingRooms.MeetingRoomRoomsGUI'
,'Aptify.Applications.MeetingManagement.MeetingRooms.MeetingRoomsLayoutControl'
,'Aptify.Framework.BusinessLogic.Alerts.AlertTypeLayout'
,'Aptify.Applications.ProductSetup.ProductCostDetailsLayout'
,'Aptify.Framework.BusinessLogic.Security.SecurityKeyFormLayout'
,'Aptify.Applications.Campaigns.CampaignCostsLayout'
,'Aptify.Applications.MeetingManagement.MeetingCloneComponent.CloneStep1LayoutControl'
,'Aptify.Applications.MeetingManagement.MeetingCloneComponent.CloneStep1LayoutControl'
,'Aptify.Applications.MeetingManagement.MeetingCloneComponent.CloneStep2LayoutControl'
,'Aptify.Applications.MeetingManagement.MeetingCloneComponent.CloneStep1LayoutControl'
,'Aptify.Applications.MeetingManagement.MeetingCloneComponent.CloneStep2LayoutControl'
,'Aptify.Applications.OrderEntry.EducationUnitsLayout'
,'Aptify.Applications.OrderEntry.EducationUnitsLayout'
,'Aptify.Applications.ProductSetup.WindowsControls.ProductLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderLayout'
,'Aptify.Applications.ProductSetup.WindowsControls.ProductLayout'
,'Aptify.Applications.MeetingManagement.MeetingsLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderLayout'
,'Aptify.Applications.OrderEntry.WindowsControls.OrderLayout'
,'Aptify.Applications.Accounting.PaymentTypesLayout'
,'Aptify.Framework.BusinessLogic.Entity.AptifyEntityBaseViewsGUI.EntityBaseViewFieldsLayout'
,'Aptify.Framework.BusinessLogic.Entity.AptifyEntityBaseViewsGUI.EntityBaseViewsLayout'
,'Aptify.Applications.Marketplace.MarketplaceListingsLayout'
,'Aptify.Applications.Marketplace.MarketplaceListingsLayout'
,'Aptify.Applications.Persons.PersonSocialNetworkMismatchesLayout'
,'Aptify.Applications.OrderEntry.RegistrationSelection'
,'Aptify.Applications.OrderEntry.RegistrationSelection'
,'Aptify.Applications.OrderEntry.OrderExpoDetailLayout'
,'Aptify.Framework.BusinessLogic.Entity.EntityBaseViewsWizardGUI.EntityBaseViewsWizardLayout'
,'Aptify.Framework.BusinessLogic.Entity.EntityBaseViewsWizardGUI.EntityBaseViewsWizardLayout'
)